﻿--12 - Найти Наиболее частовстречаемую фамилию отцов

SELECT top 1 A1.[LastName], Count(*) c
from [MyFamily].[dbo].[Persons] as A1, [MyFamily].[dbo].[Persons] as A2
where (A1.ID = A2.fk_fatherID) group by A1.[LastName]
order by c desc


